/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package sv.com.intesal.rrhh.sql;

/**
 *
 * @author JM
 */
public class SQLCargo {    

    //public static final String cargoBuscar = "SELECT * FROM CARGO order by nombre_c";
    public static final String cargoBuscar = "SELECT cargo.id_c, cargo.nombre_c, cargo.id_a, area.nombre_a FROM area, cargo WHERE area.id_a = cargo.id_a order by cargo.nombre_c";
    public static final String cargoBuscarForCombo = "SELECT cargo.id_c, cargo.nombre_c FROM cargo order by cargo.nombre_c";
    public static final String cargoInsertar = "INSERT INTO CARGO(nombre_c, id_a) VALUES(?,?)";
    public static final String cargoUpdate = "UPDATE CARGO SET nombre_c=?, id_a=? where id_c=?";
    public static final String cargoDelete = "DELETE FROM CARGO WHERE id_c=?";

}
